Tasks

  1. Find the neighbourhood_group with the highest average housing price in 2024 (from January 1, 2024, to December 31, 2024).
  2. Find the proportion of “Private room” listings priced between 0-200 in the highest-priced neighbourhood_group of 2024.
  3. Identify the top three host names based on the number of their listings that received more than 50 reviews during Q4 of 2024.
  4. Display the geographical distribution of listings for the host with the highest number of listings identified in Task 3.